Columns Section of the XML File
When a project is exported to wInsight, the columns information is exported to the <Columns> section of the XML file.
The elements information is placed in the <Columns> section in the following format:
<Columns>
<Column id="col1">
<TableID>4</TableID>
<ColName>C1</ColName>
<DataType>5</DataType>
<Length>15</Length>
<SQL>Element.C1</SQL>
<Alias>Status</Alias>
</Column>
</Columns>
During the wInsight Export process, the control account (CA) and work package (WP) codes in Cobra are exported to the Elements table in the wInsight database.
In Cobra 8.3, CA Codes 1 to 9 are exported to the C1 to C9 columns in the Elements table of the wInsight database, while WP Codes 1 to 9 are exported to the C10 to C18 columns after the wInsight Export process.
With Cobra now supporting up to 20 control account codes and 20 work package codes in 8.4, the same WP Codes to 9 are also exported to the C1 to C9 columns in the Elements table of the wInsight database. In the XML output file, the columns information is exported to the <Columns> section. CA Code 1 and WP Code 1 are now placed in C1, CA Code 2 and WP Code 2 are now stored in C2, and so on.